IF OBJECT_ID('fItemExists') IS NOT NULL 
BEGIN 
    DROP FUNCTION fItemExists
    IF OBJECT_ID('fItemExists') IS NOT NULL
        PRINT '<<< FAILED DROPPING FUNCTION fItemExists >>>'
    ELSE 
        PRINT '<<< DROPPED FUNCTION fItemExists >>>'
END
GO
CREATE FUNCTION dbo.fItemExists
(
    @objectName   nvarchar(128) = NULL
,   @propertyName nvarchar(128) = NULL
)
RETURNS bit
AS
BEGIN
    DECLARE @bit bit
    SET @bit = 0
    IF EXISTS(
        SELECT
            [object]   = o.name
        ,   [property] = p.name
        FROM
            sysObjects o
        ,   sysColumns p
        WHERE
            o.id = p.id
        AND
            o.name = @objectName
        AND
            p.name = @propertyName
 )
    BEGIN
        SET @bit = 1
    END

RETURN @bit
END
GO
GRANT EXECUTE ON fItemExists TO public
GO
IF OBJECT_ID('fItemExists') IS NOT NULL 
    PRINT '<<< CREATED FUNCTION fItemExists >>>' 
ELSE 
    PRINT '<<< FAILED CREATING FUNCTION fItemExists >>>' 
GO 